Software Development
Working with Spring Data JDBC
Final Exam: Spring Data
it_fejjm_04_enus
Working with Spring Data JDBC: An Introduction to JDBC & Spring
it_jpspdadj_01_enus
Working with Spring Data JDBC: Configuring Derived Query Methods
it_jpspdadj_03_enus
Working with Spring Data JDBC: Spring Data JDBC & the CrudRepository
it_jpspdadj_02_enus
Final Exam: Spring Data
Lesson Objectives
Final Exam: Spring Data
- apply Spring's RowMapper to operate on each row of a query execution's results and generate a Java object
- apply the @Query annotation to map queries to be run against a database to a method in a CrudRepository
- call various CrudRepository methods that are implemented by default by the Spring framework
- configure a batch process to transform XML input into CSV
- configure a CrudRepository that enables basic CRUD operations on data
- configure database tables and their corresponding entities in a Spring application to represent a many-to-many relationship
- create a batch process to read data from a JSON file and load it into a relational database table
- create a project that uses Spring Data JPA, Hibernate, and a relational database
- define an entity class that maps to a relational database table
- define an ItemReader component to read data from a CSV file and create Java objects for each row in the input file
- define custom queries that bind to parameters passed to a CrudRepository method
- define custom queries that can be referenced by names in a CrudRepository
- define database tables and their corresponding entities in a Spring application to represent a many-to-one relationship
- develop a customized FieldSetMapper to load CSV data into Java objects
- enable logging in your Spring application to view the translation of CrudRepository methods into SQL queries
- execute a Spring Batch process and identify the role played by various components in the application
- identify the features of Spring, Spring Data, and Spring Data JDBC that can be used to implement database operations from a Java application
- instantiate and persist objects that have a many-to-many relationship with one another
- load entity data from Java objects to a database table from a Spring Boot app
- read data from a database and write its contents into a JSON file
- recognize the features offered by Spring Batch to make batch processing easier and more robust
- retrieve and read entities from a database table using a CrudRepository's findBy methods
- search for entities based on patterns in a string property
- search for entities based on ranges of values in numeric and date fields
- set some of the core components of a Spring Batch application, such as a data source and transaction manager
- set up a class that represents an entity to be persisted into a database table using Spring Data JPA
- set up derived query methods that search for entities based on the values of multiple properties
- set up update and delete operations in a CrudRepository
- use a JdbcTemplate instance to connect to a database and run a query
- use Spring Boot and Spring Initializr to set up a project that adopts Spring Data JPA
Overview/Description
Final Exam: Spring Data will test your knowledge and application of the topics presented throughout the Spring Data track of the Skillsoft Aspire Javanista to Java Master Journey.
Target
Prerequisites: none
Working with Spring Data JDBC: An Introduction to JDBC & Spring
Lesson Objectives
Working with Spring Data JDBC: An Introduction to JDBC & Spring
- discover the key concepts covered in this course
- recognize the features of JDBC and how it simplifies database access
- identify the features of Spring, Spring Data, and Spring Data JDBC that can be used to implement database operations from a Java application
- use Spring Initializr to generate a Spring Boot application that uses Spring Data JDBC
- use a JdbcTemplate instance to connect to a database and run a query
- execute create, read/retrieve, update, and delete queries against a database using a JdbcTemplate instance
- define an entity class that maps to a relational database table
- apply Spring's RowMapper to operate on each row of a query execution's results and generate a Java object
- implement read and update operations on a database with a data access layer class
- summarize the key concepts covered in this course
Overview/Description
Java Database Connectivity (JDBC) is a Java API that provides developers with a common interface for connecting to a database, issuing queries and commands, and handling responses from the database. Learn more about JDBC in Spring and JdbcTemplate class through this course. Start by exploring the Spring framework and its JDBC APIs to understand the features available in relation to database integration. You will then get hands-on experience using Spring Boot to set up an application that uses Spring JDBC to connect to a database and run queries against it. The course will also help you investigate the implementation of CRUD (i.e., create, read, update, and delete) operations using a JdbcTemplate class, mapping a database table to a Java class, and the role of Spring's RowMapper interface to translate rows from a query execution to Java objects. After completing this course, you'll have a solid grasp of how the Spring framework simplifies database integration from a Java app.
Java Database Connectivity (JDBC) is a Java API that provides developers with a common interface for connecting to a database, issuing queries and commands, and handling responses from the database. Learn more about JDBC in Spring and JdbcTemplate class through this course. Start by exploring the Spring framework and its JDBC APIs to understand the features available in relation to database integration. You will then get hands-on experience using Spring Boot to set up an application that uses Spring JDBC to connect to a database and run queries against it. The course will also help you investigate the implementation of CRUD (i.e., create, read, update, and delete) operations using a JdbcTemplate class, mapping a database table to a Java class, and the role of Spring's RowMapper interface to translate rows from a query execution to Java objects. After completing this course, you'll have a solid grasp of how the Spring framework simplifies database integration from a Java app.
Target
Prerequisites: none
Working with Spring Data JDBC: Configuring Derived Query Methods
Lesson Objectives
Working with Spring Data JDBC: Configuring Derived Query Methods
- discover the key concepts covered in this course
- enable logging in your Spring application to view the translation of CrudRepository methods into SQL queries
- call various CrudRepository methods that are implemented by default by the Spring framework
- configure derived query methods that search for entities based on a parameter
- set up derived query methods that search for entities based on the values of multiple properties
- configure derived query methods that search the numeric fields of entities for values in a given range
- set up derived query methods that return entities in a specified order
- summarize the key concepts covered in this course
Overview/Description
Configuring derived query methods in Spring Data's CrudRepository enables the execution of complex queries and the processing of their results without the developer having to write any SQL. Use this course to explore CrudRepository and different query methods in greater detail. Learn more about the steps involved in enabling logging for your Spring application and configuring methods in your CrudRepository that retrieve specific entities from a database table based on the method's signature. You'll also examine different types of queries that can be implemented, such as exact match lookups, range searches, and ordering of results. After completing this course, you'll have acquired the skills to build robust and easy-to-maintain applications.
Configuring derived query methods in Spring Data's CrudRepository enables the execution of complex queries and the processing of their results without the developer having to write any SQL. Use this course to explore CrudRepository and different query methods in greater detail. Learn more about the steps involved in enabling logging for your Spring application and configuring methods in your CrudRepository that retrieve specific entities from a database table based on the method's signature. You'll also examine different types of queries that can be implemented, such as exact match lookups, range searches, and ordering of results. After completing this course, you'll have acquired the skills to build robust and easy-to-maintain applications.
Target
Prerequisites: none
Working with Spring Data JDBC: Spring Data JDBC & the CrudRepository
Lesson Objectives
Working with Spring Data JDBC: Spring Data JDBC & the CrudRepository
- discover the key concepts covered in this course
- map an entity in your application to Spring Data's CrudRepository and use it to persist Java objects to a database
- map custom queries to a method in a CrudRepository
- define database tables and their corresponding entities in a Spring application to represent a many-to-one relationship
- create and persist objects that are related to one another in a many-to-one form
- configure database tables and their corresponding entities in a Spring application to represent a many-to-many relationship
- instantiate and persist objects that have a many-to-many relationship with one another
- summarize the key concepts covered in this course
Overview/Description
CrudRepository is a Spring Data interface that helps perform generic CRUD operations on specific types of repositories. Take this course to familiarize yourself with Spring Data's CrudRepository interface and modeling of relationships between entities in a Spring application. Delve into how CrudRepository is used to persist Java objects into a database table and examine Spring Data JDBC's Query annotations to map custom queries to CrudRepository methods. You'll then turn your attention to modeling relationships between entities in a Spring application and configure and implement many-to-one and many-to-many relationships. Having finished this course, you'll have a broader understanding of the features in the Spring Framework that make JDBC tasks easier.
CrudRepository is a Spring Data interface that helps perform generic CRUD operations on specific types of repositories. Take this course to familiarize yourself with Spring Data's CrudRepository interface and modeling of relationships between entities in a Spring application. Delve into how CrudRepository is used to persist Java objects into a database table and examine Spring Data JDBC's Query annotations to map custom queries to CrudRepository methods. You'll then turn your attention to modeling relationships between entities in a Spring application and configure and implement many-to-one and many-to-many relationships. Having finished this course, you'll have a broader understanding of the features in the Spring Framework that make JDBC tasks easier.
Target
Prerequisites: none
